package com.sfac.springCloudAccount.dao;

import com.sfac.account.UserRole;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.springframework.stereotype.Repository;

/**
 * User Role Dao
 */
@Repository
@Mapper
public interface UserRoleDao {

	@Insert("insert into account_user_role (user_id, role_id) values (#{userId}, #{roleId})")
	@Options(useGeneratedKeys = true, keyColumn = "id", keyProperty = "id")
	void insertUserRole(UserRole userRole);

	@Delete("delete from account_user_role where user_id = #{userId}")
	void deleteUserRolesByUserId(int userId);
}
